spacing between numbers in a cell

[amitojsingh999]

hi,
if i have a string o numbers in a cell..say..1234567890 and i want to make it look like 123 456 7890, what will be the way ( notice the spacing between digits)

Amitoj

 

[mhartman]

Hello:

In your cell select Format, Cells, Custom from the menu.

This allows you to construct a custom view for your data. There are some made already that can be modified.

Regards
Mark

 

[mhartman]

Hello:

The Format mask would be the following:

000 0000 0000

Regards
Mark

 

[amitojsingh999]

thank you !

Thank you guys...I didnt know it was so simple !

 

[mhartman]

Hello: Your welcome.

Mark