spacing between numbers in a cell

amitojsingh999

New member
Local time
Today, 07:18
Joined
Jan 19, 2007
Messages
2
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
 
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
 
Hello:

The Format mask would be the following:

000 0000 0000

Regards
Mark
 

Users who are viewing this thread

Back
Top Bottom