View Full Version : spacing between numbers in a cell


amitojsingh999
01-19-2007, 09:44 AM
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
01-19-2007, 10:32 AM
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
01-19-2007, 10:36 AM
Hello:

The Format mask would be the following:

000 0000 0000

Regards
Mark

amitojsingh999
01-19-2007, 01:12 PM
Thank you guys...I didnt know it was so simple !

mhartman
01-19-2007, 01:24 PM
Hello: Your welcome.

Mark