Simple question - Add a . to the end of a number

**Clint** · 05-03-2012, 04:18 AM

Hi,

Just a simple request...

I have a number 123123 and I need to add a "." to the end of it. Therefore, 123123.

Thanks if someone could let me know the formula.

Clint

**vlady** · 05-03-2012, 04:20 AM

format cell custom enter

0.

**zbor** · 05-03-2012, 04:21 AM

Try: =A1&"."

Or right click -> Format cells -> Custom -> 0"."

**Mallycat** · 05-03-2012, 04:21 AM

If you only want this for display purposes, then just create a custom format. On the home ribbon, open the number menu, select custom and enter 0.

**Fotis1991** · 05-03-2012, 04:21 AM

Hi and welcome to the forum.

One way is this.

=A1&"."

**Mallycat** · 05-03-2012, 04:22 AM

Wow, we all had our fingers hovering over the enter button on that one!!

**Fotis1991** · 05-03-2012, 04:23 AM

Yes. We did!

**vlady** · 05-03-2012, 04:28 AM

everything starts--- in a single dot

**Clint** · 05-03-2012, 04:34 AM

Wow, perfect thanks - what a great response to my first question on the forum

Dont worry, I will have loads more questions for you all to fight over

Simple question - Add a . to the end of a number

LinkBack

Thread Tools

Rate This Thread

Display

Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Re: Simple question - Add a . to the end of a number

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions