New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Dots between numbers

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Dots between numbers

Postby Shuvo6 » Wed Aug 10, 2016 2:02 pm

HI

I want to add dot between the digits of the numbers in my worksheet
i want to add a dot between $2,708
i.e. make it $27.08 in my workbook, i have different numbers in every row for eg $5,246 , $7,764 etc want to make them $52.46 , $77.64 etc...kindly help
Thanks!
  • 0

Shuvo6
Rookie
 
Posts: 1
Joined: Aug 10, 2016
Reputation: 0
Excel Version: 2007

Re: Dots between numbers

Postby Kevin UK » Thu Aug 11, 2016 12:29 am

Hi

Format your cells as "$0"."00" without the red quotes.

Or if your data is in column A, in column B use the following and copy down, format the cells as required.

Code: Select all
=A1/100
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 62 guests